Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL Tutorial
1) Aggregate Functions
2) Cast Functions Operators
3) Comparison Functions Operators
4) Control Flow Functions
5) Cursor
6) Data Dictionary
7) Data Types
8) Database
9) Date Time Functions
10) Encryption Compression Functions
11) Information Functions
12) Insert Update Delete
13) Introduction
14) Logic Operator
15) Math Numeric Functions
16) Miscellaneous Functions
17) MySQL Utilities
18) Privilege
19) Procedure Function
20) Regular Expressions
21) Select Query
22) String Functions
23) Subquery
24) Table
25) Table Join
26) Trigger
27) View

MySQL Utilities
1) Automatically drop any tables that exist before restoring the stored tables with the --add-drop-table
2) Continue even if errors in batch mode, you should use the --force command-line option
3) Create the database if it doesnt already exist with --databases option to specify the database we wish to back up
4) Delay an INSERT statement until the table is no longer in use
5) Display all table names
6) Execute an UPDATE statement when no one else is using the table
7) Exporting Data
8) If anonymous (unnamed) user is allowed, you should be able to connect to that server by invoking mysql without any options
9) If you are logging in on the same machine that MySQL is running on, you can omit the host
10) If you need to specify connection parameters on the command line in batch mode
11) Importing data
12) LOAD DATA INFILE into a table
13) Load data to your table
14) Logging In with mysql
15) Mysqldump
16) Mysqlhotcopy
17) Mysqlimport
18) Non-Interactive Commands
19) Optimising a dump
20) Remote Client Connection
21) Restoring a Dump
22) Run the output through a pager
23) Select into a DUMPFILE
24) Select into a file with starter
25) Select into a file with terminator and encloser
26) Select into a file with terminator, encloser and Escaper
27) Select into a file with where clause
28) Select into with Line and field separator
29) Show a detailed listing of the columns of your database
30) SHOW COLUMNS and DESCRIBE can display information about the columns in individual INFORMATION_SCHEMA tables
31) SHOW CREATE TABLE statement
32) SHOW INDEX FROM tbl_name
33) SHOW WARNINGS
34) Supply your password on the command line after the -p option
35) To escape some special characters in the file
36) To force MySQL to perform the SELECT first
37) To have a DELETE statement execute while no one else is reading from the table
38) To make a copy of live data
39) To see a list of options provided by mysql, invoke it with the --help option
40) To see the structure or schema of a database
41) Turn Exporting and Importing Data on
42) Use scripts from the mysql prompt by using the source command or command
43) Use the SHOW statement to find out what databases currently exist on the server
44) Using a STATUS command
45) Using mysql in Batch Mode
46) Using mysqldump to copy databases
47) You can catch the output in a file for further processing
48) You can disconnect any time by typing QUIT (or q) at the mysql prompt
49) You can select the database on the command line when you invoke mysql